home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Magnum One
/
Magnum One (Mid-American Digital) (Disc Manufacturing).iso
/
d13
/
qptech.arc
/
TI533.ASC
< prev
next >
Wrap
Text File
|
1991-04-25
|
6KB
|
265 lines
PRODUCT : Quattro Pro NUMBER : 533
VERSION : All
OS : DOS
DATE : March 16, 1991 PAGE : 1/4
TITLE : Text Formulas
Text formulas are formulas that result in a textual entry. Text
formulas include those created with string functions (see the
User's Guide) or an @function that results in a string.
There are (generally) three parameters to a concatenated string:
1. + The plus symbol (+) specifies the trailing text as
a formula. Always begin a text formula with a '+'
sign.
2. constant The constant is the part of the formula which will
not change. Constants should be placed within
quotes.
3. variable The variable is the part of the formula which is
being concatenated to the constant. It is
preceded by an ampersand (&), and should be
followed by another ampersand if there is more
information to add (concatenate) to the end of the
string. Variables must be valid text strings.
Use the @STRING function if the variable is not a
text string -- this converts the variable to a
string format.
EXAMPLES
Example 1
+"Book"&" Review"
This example concatenates the text string "Book" with the text
string " Review". The result is "Book Review".
If you break this example into its appropriate parts, you will
find a '+' sign (denoting a formula), and two constants ("Book"
and " Review"). In this case, there is no variable. This is a
redundant type of example, but it does show the manipulation of
strings in formulas.
PRODUCT : Quattro Pro NUMBER : 533
VERSION : All
OS : DOS
DATE : March 16, 1991 PAGE : 2/4
TITLE : Text Formulas
Example 2
+C4&" Review"
This example takes the contents of cell C4, adds a space and the
text 'Review' to C4's contents. If C4 contains the label 'Book',
the result of this formula will be 'Book Review'.
Again, note the '+' sign beginning the formula. However, C4
becomes the variable. Since the contents of C4 can change at any
time, it is referenced as a variable. The constant in this case
is " Review". In this example, it is assumed that C4 contains a
label. The next example shows the formula needed if C4 contains
a value.
Example 3
+@STRING(C4,0)&" Review"
This example is similar to the previous one except the @STRING
function is used to translate a value in C4 to a string so it can
be used in the formula. If C4 contains the value '4', the result
is "4 Review".
Example 4
+"{GETLABEL ""Enter Name: "","&@CELLPOINTER("address")&"}"
This example prompts the user for a name and places the response
in the current cell since {GETLABEL} requires a valid block in
which to store the response. Since the address in this example
is variable, the address is added when the command is executed.
* * * * * *
+ "{GETLABEL ""Enter Name: ""," &@CELLPOINTER("address") &"}"
│ └────────────┬──────────────┘ └──────────┬───────────┘ └─┬┘
P First Variable Second
L Constant Constant
U
S
* * * * * *
PRODUCT : Quattro Pro NUMBER : 533
VERSION : All
OS : DOS
DATE : March 16, 1991 PAGE : 3/4
TITLE : Text Formulas
+ Indicates the following text as a formula.
"{GETLABEL ""Enter Name: "","
The first constant. Notice that the constant is
enclosed in quotes while the prompt for {GETLABEL}
is enclosed in a pair of quotes. This is
necessary so one set of quotes will appear after
the string formula has been calculated.
&@CELLPOINTER("address")
This is the variable. Notice the result of this
function will be a text string (the address of the
current cell). Notice the ampersand (&), which
indicates the following string should be appended
(concatenated) to the previous string (the first
constant).
&"}" The second constant. Notice that the constant is
enclosed in quotes. Since the string is to also
be appended within the formula, it too is preceded
by an ampersand.
Example 5
+"{LET "&@CELLPOINTER("address")&",A25}"
This example takes the contents of cell A25 and places it in the
cell referenced by the cell selector. This initializes the
current cell to the contents of cell A25.
* * * * * *
+ "{LET " &@CELLPOINTER("address") &",A25}"
│ └──┬──┘ └──────────┬───────────┘ └───┬──┘
P First Variable Second
L Constant Constant
U
S
* * * * * *
PRODUCT : Quattro Pro NUMBER : 533
VERSION : All
OS : DOS
DATE : March 16, 1991 PAGE : 4/4
TITLE : Text Formulas
+ Indicates the following text is a formula.
"{LET " The first constant. Notice that the constant
is enclosed in quotes.
&@CELLPOINTER("address")
The variable. Notice that the result of this
function will be a text string (the address
of the current cell). Also, notice the
ampersand (&), which indicates the following
text string should be concatenated to the
previous string (the first constant).
&",A25}" The second constant. The ampersand indicates
that this constant should be appended to the
previous string. Notice the quotes around
the constant.
When a text formula is used within a macro, precede the
concatenate command with a {CALC} command. Spreadsheet
recalculation is suspended while a macro executes. Therefore, to
ensure that all text formulas are current before executing them,
the {CALC} command should be used to update the formulas.
Concatenating text strings takes practice and patience. Try
manipulating other sorts of text strings until you are
comfortable with the operation.